TMemDataSet class overview.
Properties
  
    | Name |     Description |   
  
    | 
 CachedUpdates      | 
    
Used to enable or disable the use of cached updates for a dataset. 
     | 
  
  
    | 
 IndexFieldNames      | 
    
Used to get or set the list of fields on which the recordset is sorted. 
     | 
  
  
    | 
 KeyExclusive      | 
    
Specifies the upper and lower boundaries for a range. 
     | 
  
  
    | 
 LocalConstraints      | 
    
Used to avoid setting the Required property of a TField component for NOT NULL fields at the time of opening TMemDataSet. 
     | 
  
  
    | 
 LocalUpdate      | 
    
Used to prevent implicit update of rows on database server. 
     | 
  
  
    | 
 Prepared      | 
    
Determines whether a query is prepared for execution or not. 
     | 
  
  
    | 
 Ranged      | 
    
Indicates whether a range is applied to a dataset. 
     | 
  
  
    | 
 UpdateRecordTypes      | 
    
Used to indicate the update status for the current record when cached updates are enabled. 
     | 
  
  
    | 
 UpdatesPending      | 
    
Used to check the status of the cached updates buffer. 
     | 
  
Methods
  
    | Name |     Description |   
  
    | 
 ApplyRange      | 
    
Applies a range to the dataset. 
     | 
  
  
    | 
 ApplyUpdates      | 
    
Overloaded.
Writes dataset's pending cached updates to a database. 
     | 
  
  
    | 
 CancelRange      | 
    
Removes any ranges currently in effect for a dataset. 
     | 
  
  
    | 
 CancelUpdates      | 
    
Clears all pending cached updates from cache and restores dataset in its prior state. 
     | 
  
  
    | 
 CommitUpdates      | 
    
Clears the cached updates buffer. 
     | 
  
  
    | 
 DeferredPost      | 
    
Makes permanent changes to the database server. 
     | 
  
  
    | 
 EditRangeEnd      | 
    
Enables changing the ending value for an existing range. 
     | 
  
  
    | 
 EditRangeStart      | 
    
Enables changing the starting value for an existing range. 
     | 
  
  
    | 
 GetBlob      | 
    
Overloaded.
Retrieves TBlob object for a field or current record when only its name or the field itself is known. 
     | 
  
  
    | 
 Locate      | 
    
Overloaded.
Searches a dataset for a specific record and positions the cursor on it. 
     | 
  
  
    | 
 LocateEx      | 
    
Overloaded.
Excludes features that don't need to be included to the TMemDataSet.Locate method of TDataSet. 
     | 
  
  
    | 
 Prepare      | 
    
Allocates resources and creates field components for a dataset. 
     | 
  
  
    | 
 RestoreUpdates      | 
    
Marks all records in the cache of updates as unapplied. 
     | 
  
  
    | 
 RevertRecord      | 
    
Cancels changes made to the current record when cached updates are enabled. 
     | 
  
  
    | 
 SaveToJSON      | 
    
Overloaded.
Saves the current dataset data to a file or a stream in the JSON format. 
     | 
  
  
    | 
 SaveToXML      | 
    
Overloaded.
Saves the current dataset data to a file or a stream in the XML format compatible with ADO format. 
     | 
  
  
    | 
 SetRange      | 
    
Sets the starting and ending values of a range, and applies it. 
     | 
  
  
    | 
 SetRangeEnd      | 
    
Indicates that subsequent assignments to field values specify the end of the range of rows to include in the dataset. 
     | 
  
  
    | 
 SetRangeStart      | 
    
Indicates that subsequent assignments to field values specify the start of the range of rows to include in the dataset. 
     | 
  
  
    | 
 UnPrepare      | 
    
Frees the resources allocated for a previously prepared query on the server and client sides. 
     | 
  
  
    | 
 UpdateResult      | 
    
Reads the status of the latest call to the ApplyUpdates method while cached updates are enabled. 
     | 
  
  
    | 
 UpdateStatus      | 
    
Indicates the current update status for the dataset when cached updates are enabled. 
     | 
  
Events
  
    | Name |     Description |   
  
    | 
 OnUpdateError      | 
    
Occurs when an exception is generated while cached updates are applied to a database. 
     | 
  
  
    | 
 OnUpdateRecord      | 
    
Occurs when a single update component can not handle the updates. 
     |